SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 621010 LIMIT 1 [ RunTime:0.000769s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 621010 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873985,505619,721392,55149,35777,714670,174678,105019,519092,975488,470939,340847,10671,603726,484021,497189,107472,776055,898144,1009833,829897,986504,38302,592899,841031,192548,757712,492035,86141,975853,994525,597683,872524,859499,832317,273236,93066,958516,574172,32387,1010540,79224,70678,414050,979146,1016637,990893,987017,130767,691802,115941,190114,379009,92322,313246,715587,83378,245684,23484,1036251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 621010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 621010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]