SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 987610 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 987610 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314779,305066,600795,339830,673497,534233,412768,728400,458850,742215,535539,755839,864779,244993,633826,198150,433582,862791,753700,784765,313337,487930,559545,270105,762189,39406,149888,825854,975463,261842,753718,354340,214753,429624,910964,216688,208575,1024556,1042027,258547,1048460,617165,797434,169647,536605,478038,703249,854406,480536,979124,200994,683954,577952,643710,166631,932915,132317,176619,977959,564343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 987610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 987610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]