SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417436 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417436 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81193,49419,206461,41659,1008028,321742,50155,1013216,359587,516699,172621,396224,178653,780653,534779,1012092,220740,1033444,185272,805294,119259,647112,356397,421451,782917,972594,262596,560502,132310,659507,376362,615524,152893,756689,619288,565829,781624,301826,875584,444880,954833,844828,418504,518317,741665,669548,1005581,37212,391037,865555,95184,308143,610447,483219,447970,258107,734080,1732,330970,904509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]