SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563942 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563942 [ RunTime:0.002856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155881,106577,425447,229051,531836,700227,1004194,21910,866350,449002,422271,3206,990917,240607,445095,403099,432098,8728,764278,285550,808814,170524,980104,173636,462141,278617,499664,353579,339952,357890,443055,429879,375479,826221,490071,1022468,727654,981161,702688,540151,387051,302103,297970,362932,161360,600480,19952,404009,895420,1029263,319478,47775,41992,791439,535402,281689,1038083,504156,770065,698044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]