SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435534 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435534 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347123,916608,824105,987085,74163,70355,823062,722939,316328,27692,876478,178937,668888,315140,167757,185751,631545,1021594,860642,469987,842730,59316,739394,893026,590439,414480,332476,298762,717072,273968,941396,770431,353888,562341,205043,201487,366646,71010,46998,1005002,778067,661702,981504,904387,176607,1015435,732017,104550,578484,807719,794146,669983,886089,497476,77279,510075,665236,760808,702432,602700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]