SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381748 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381748 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217516,43713,716003,16443,887102,224339,734350,682411,1010940,734602,795638,476736,46712,696284,614654,696274,806745,313035,752634,484979,880767,987973,266106,540551,590551,483569,947103,555322,625713,328865,278768,922099,333018,764322,863186,226166,484753,98286,1023479,133390,197744,412232,94597,562395,300460,790687,438769,1010813,804779,844350,703294,201557,512033,502081,305697,969849,1033078,946661,125237,365276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]