SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543961 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543961 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244413,120021,167882,647996,392926,71698,209177,435087,164988,819158,775904,876624,861304,337834,1016584,1007545,984239,601596,885583,663158,255567,307945,333363,886389,442154,633611,320430,374035,1021,314195,34405,964479,249975,720546,180912,346437,206348,457141,539870,189832,902598,227535,496198,733926,416919,313897,414171,629495,67874,457571,664965,971754,261812,678207,480019,139745,24669,310498,978384,32729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]