SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447731 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447731 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843588,636426,128066,109713,105733,136049,358203,1027875,90802,230917,527338,495681,235180,912784,693288,496161,370434,251623,672413,910865,15267,664816,1007984,875764,687482,1015166,269977,103875,71159,406456,433905,780537,413021,534268,626093,1001260,759527,304704,739330,426465,614980,66344,221847,474049,413889,971847,257656,335837,670456,768409,892373,130169,658533,645327,1043372,882220,974918,957046,679117,110156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]