SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475440 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475440 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293940,319019,1037539,847864,766890,980732,48455,974324,992725,580048,790946,329136,218559,352514,245179,170975,27565,898065,389160,644305,900560,39298,711065,611577,446614,51811,742115,5678,937500,871408,942133,844287,848622,925988,644633,788217,149696,558105,409606,57193,760991,539018,729294,685166,211656,101608,764276,999096,235530,684383,790674,488792,927031,751734,37086,640740,543403,883971,108683,939513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000356s ]