SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046881 LIMIT 1 [ RunTime:0.004323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046881 [ RunTime:0.005891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520754,617366,623974,336358,1045821,998525,138239,966669,861378,425059,599752,28204,302820,944365,15119,119749,316678,542303,1037937,521018,373179,655552,251982,186016,468449,294441,1033458,71401,529384,735332,437158,319982,468131,524014,727378,466770,875220,799738,262412,252582,519955,480148,471543,381512,998177,552618,416889,556269,457180,292991,337257,629543,883033,748005,860333,713821,1022751,483854,70505,214783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]