SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284094 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284094 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288942,783106,573832,307660,189813,1022365,731227,647990,157154,284360,78429,633116,649707,47481,647942,865864,387556,614123,794527,187573,616813,837667,494042,696443,481448,418349,930045,435605,953520,557357,514707,985949,836544,160433,51152,182711,281412,1030665,38975,98733,135981,132995,166067,141236,1037872,478225,385532,646137,242260,571808,910458,211023,702984,777098,1029673,79739,860193,937470,278985,702400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]