SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149201 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149201 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137173,440595,352379,677752,462944,574194,282481,1031269,387629,507498,933411,9144,598977,363291,34428,434844,1000671,439588,685209,468194,199509,226306,820427,121033,897028,716982,624380,711315,425639,444665,136889,840358,491892,227550,28753,204120,32601,14359,830760,185336,280809,1021668,869939,529690,97159,242423,736931,489448,601773,474166,815078,1035978,439386,834378,768650,704608,853213,262238,470773,629175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]