SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265198 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265198 [ RunTime:0.004246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275410,140053,769605,223481,1019583,457948,387604,123273,517916,227851,900137,49362,553907,386901,778326,462670,140487,679921,791084,1009417,301787,718380,14178,760593,23127,772528,476531,377662,294337,844304,857784,1028526,712187,209863,313474,156599,985126,800542,585016,412998,432554,383142,629037,569,426951,839958,1015018,853235,27860,586299,839134,567470,380113,90917,512028,550994,675973,879507,690396,735637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]