SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283178 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283178 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162002,679279,208267,270541,220468,505559,896594,239325,240157,162928,167804,845449,683877,610008,775198,642185,441113,220048,826272,971160,156566,979351,31187,815181,196763,960276,683719,143178,621555,679110,1035792,407824,451481,942953,207976,123,179427,740703,435674,721542,185312,689773,804474,335706,560871,319958,127301,631638,874920,464666,759268,370940,554170,842554,23186,438852,21302,52071,773437,394107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]