SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 638650 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 638650 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256040,1024703,782109,824238,334514,212953,47203,498017,60466,999240,234854,795404,415568,794028,656530,783576,898941,572084,421323,7575,283042,414606,771641,622456,640388,679073,755238,88700,526789,633692,189561,314132,157552,859818,243155,805130,1036439,769949,184127,192242,724889,163754,54181,156472,216146,306759,431584,644236,1019178,169719,599654,86386,71020,986682,400362,824561,995384,88533,265837,405423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 638650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 638650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]