SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500985 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500985 [ RunTime:0.002742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028022,428817,6067,183669,299758,103572,945888,301481,170714,405021,1010883,846376,453517,408109,547975,139429,542137,545792,296749,568739,629350,765828,785134,728701,564349,254263,871653,583794,242472,377848,555621,951453,154094,299772,650512,339119,1048534,489628,946250,604197,368042,108065,119215,273763,169548,291710,726744,462158,161153,87984,1001556,596630,116388,427144,340153,336251,884880,933633,204440,812204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002011s ]