SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267051 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267051 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447490,585777,268287,353657,245084,647774,467094,822396,232944,456032,406544,37395,6765,3773,813023,799218,304487,637991,478467,334684,469785,326387,484251,270771,169131,642091,819026,666850,337781,412786,552180,442767,192729,729351,113158,707627,760107,707616,709917,4174,255060,583513,530456,154873,489672,184131,501921,641201,158748,509195,675430,946032,649119,242019,333045,576197,379081,288158,22154,896197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]