SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004818s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264211 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264211 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179428,891061,694325,798584,339424,136810,928036,822889,75037,220148,607659,863076,510876,703118,393487,1024393,110280,405145,454376,791812,786613,732116,420849,463862,911873,737464,327534,104127,34228,1015229,694424,672017,148903,494353,873753,171239,54143,762120,405912,478757,649902,662200,66096,748580,928977,795611,510976,243033,872389,1021358,778189,977839,44852,43180,966966,176289,1043253,429833,908052,348630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]