SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291039 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291039 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41022,648193,812318,699378,164780,24839,19542,339850,476022,182993,188592,875272,157892,539771,13286,155308,816213,926763,483631,49720,236492,309181,756307,181955,970447,247765,901123,175751,788961,536244,635638,949908,156451,869298,723304,277903,351305,241303,743722,443978,214687,503120,484300,90804,107060,390129,1036113,550091,862371,3121,117467,324019,335554,1001267,976765,1037564,77835,900348,99002,827141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]