SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426103 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426103 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375987,674431,430971,1031767,35933,911970,949605,318212,349037,797531,737948,397701,107506,753520,1012280,808953,473483,627149,805658,738208,223807,499357,982600,1045985,267403,655548,618368,857625,26180,575174,832162,49339,350079,392081,599998,39484,19261,555236,693218,286885,534951,549516,921268,866248,185320,479654,728709,410755,342052,203862,786957,43076,302420,928982,641994,481806,881023,552982,634053,1007345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]