SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538568 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538568 [ RunTime:0.002963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460182,774618,281302,914759,830051,11790,118844,529035,151026,746205,279034,558481,145484,704526,155727,730712,1015245,405284,739586,158655,3162,845854,119982,258259,233622,61226,568109,585274,449226,846250,969860,983546,394137,641413,100742,181840,906925,675594,1007146,626886,968781,386739,64146,124206,839623,197519,895706,602873,14013,796067,244125,1040600,939939,458876,298047,511557,373644,491136,251938,209949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]