SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429990 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429990 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479999,1026400,114983,127530,1030944,656310,476219,829219,664359,825380,886610,574467,96243,688423,437151,93140,1036418,495325,76136,503767,629417,812562,237957,359053,391087,185307,558146,97026,766603,968095,179312,463064,548998,469322,378369,104284,224279,226654,184853,692909,41253,119377,1047688,385088,901914,265540,556423,331331,1023044,950265,241569,669254,448614,367875,280913,430574,182034,586097,1026651,344789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000371s ]