SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566493 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566493 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105072,881688,510273,9723,512398,117668,806729,382614,462901,996091,303817,426282,1026811,261695,877979,390436,71352,164695,723778,239694,149154,281269,552085,884505,1036328,466302,936833,450618,1004057,1019753,169040,421586,161683,952265,429704,474395,402383,608178,383585,838091,762426,227806,577396,766150,910753,379466,964435,633745,933982,334379,257901,79866,939893,905183,441930,796489,207095,475955,869238,901385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]