SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465253 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465253 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328125,115006,101565,54657,659563,861980,443359,837908,480658,72788,166662,12019,388413,424436,497349,934698,706658,896870,965021,779504,806456,516652,39063,557064,1045485,333039,292766,621365,205693,905492,281494,32956,181206,1033791,450204,393344,176467,834318,355292,113190,404630,323861,874583,247395,649971,645640,824156,403317,676201,1008155,992933,805954,917897,392138,255021,583040,93696,760581,246204,470779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]