SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840139 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840139 [ RunTime:0.003896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40013,443255,233913,129465,811433,439918,629890,812877,553383,39698,58316,565122,629223,511055,921873,245386,329038,20042,704713,608674,428242,834321,260737,303788,657125,889439,330564,798597,794729,142432,393771,574033,714715,358915,87525,761172,379145,489783,278093,1017968,595952,907195,940380,9443,35685,147275,887869,221870,36947,212425,244402,266118,911511,365702,453770,872549,718026,603068,684016,17079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]