SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42599 LIMIT 1 [ RunTime:0.001208s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42599 [ RunTime:0.002188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447360,297021,321261,539366,244276,53505,980450,254110,736429,515887,595837,339873,870135,1029212,150447,29069,29617,899342,1035151,398380,690174,648685,508966,753900,615756,653266,194049,955402,110006,965560,947815,92369,888507,209855,786209,551548,25569,601729,1048520,524293,738440,75342,934949,555875,559161,433399,227179,972859,462847,223748,849030,921980,333220,118871,538285,908033,402762,1026601,743825,562372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]