SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512962 LIMIT 1 [ RunTime:0.001241s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512962 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993986,72581,142749,20511,652521,942249,828442,1041987,485563,332533,286106,562819,302012,530048,879147,318463,155871,867090,58174,182750,168420,834118,41284,645363,93597,293284,885655,973029,846026,64590,2811,830968,857868,523567,44140,738884,663187,147993,546430,790449,289225,374162,944212,790261,117508,184839,4520,910432,901411,110328,360972,415125,171067,1034390,27197,849577,587442,959251,471846,391003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]