SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804516 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804516 [ RunTime:0.002144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581805,439764,343404,248204,711888,852543,27527,223542,779863,242725,598954,163158,370038,281732,210566,435766,620004,788203,949128,666875,513707,617091,259185,246918,527164,985279,803183,333091,1000480,950987,51877,540175,185574,250187,779474,361644,666701,845218,610452,744540,139730,605689,514126,916602,355024,719681,1012359,900734,981246,369872,1364,500428,751206,994142,117568,780200,775706,476988,182607,192003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]