SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504899 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504899 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156770,198999,719456,267193,542601,225356,343970,222867,600725,438974,185878,729206,819956,503039,181265,871537,718464,274264,241716,283473,399365,178549,953079,95310,573314,521168,349130,7215,45039,83457,1003909,369071,954229,829788,154975,331484,143528,534805,1039659,145645,800838,961244,28314,622286,555470,708529,281348,389458,17940,961766,738025,83641,24988,714739,291849,379279,500023,82557,308009,397264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]