SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430620 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430620 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600410,907162,148644,912297,394682,344043,320051,911087,783583,210141,433334,1001011,640509,951781,711922,730440,864800,107080,754192,210331,51988,634605,791708,341704,505176,73041,950037,48843,852750,102842,427665,529882,420757,417374,81022,82712,104727,430194,792492,55287,675705,479445,82145,399286,901670,783686,901445,431912,329891,275565,76897,523949,272165,105158,278926,309742,87307,693761,789275,60883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]