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` = 593140 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593140 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51930,352658,918806,972770,553083,302014,600469,116246,304759,764311,841536,261264,1023840,471306,839403,638120,97630,487379,229315,93697,58467,714563,893894,22965,385004,563339,3916,9108,347953,875548,584735,674260,425411,823234,859044,495936,823094,74389,984264,333126,246576,45480,566211,79741,199760,129317,501541,591085,1001717,125848,886635,566021,429699,614805,1048460,1043034,266132,736927,692485,826560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]