SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486847 LIMIT 1 [ RunTime:0.000953s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486847 [ RunTime:0.006367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930919,569235,391499,786134,898875,156820,356647,374086,430717,167459,1048237,490775,274903,722981,768193,303425,963764,850044,99078,4358,503051,799803,627454,179799,912484,533496,462586,287871,190900,980358,157260,217115,779545,868558,530051,329818,522941,261096,295360,486295,15542,600919,128475,1032179,194708,24704,508239,195827,698674,571092,140908,6503,161457,800438,764986,1046396,357850,801017,975991,163244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000975s ]