SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110138 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110138 [ RunTime:0.003062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674319,14898,864677,878073,1045081,629605,71389,587582,820109,443435,963924,274810,1008521,13459,12107,289242,454790,160130,966089,91934,336137,411690,121990,732983,468209,987086,586803,351609,543006,899890,643121,560944,714317,238574,680280,156913,998895,950375,963769,5242,585837,204173,392731,143725,141918,966897,580222,524947,791239,479053,543013,265362,199830,53633,335510,281737,217159,785841,559004,188387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]