SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445273 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445273 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865078,531781,365064,832010,361000,193605,401318,254916,461920,413766,539190,199051,313426,218712,301844,764584,404250,809354,1019195,1000490,184086,269312,452242,919183,96952,819964,198826,792097,118960,230101,836457,721219,850517,583462,734760,898601,128248,18010,335972,434516,603038,429151,55641,702036,609491,303564,143740,821518,483749,817775,979454,748788,334373,357546,603725,117313,446813,670232,590684,885969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]