SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544043 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544043 [ RunTime:0.002994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856960,733750,254197,3716,758962,981622,515351,954751,1040713,792912,202973,447514,1042992,262544,614048,305176,709567,995006,761706,368403,1024752,261549,619170,897473,473600,85985,804102,1046869,116658,476598,382150,703438,861959,668320,258558,710326,362650,41901,386234,928892,701059,1041543,112825,627799,336439,614775,701360,994774,660049,25973,209226,249001,1015567,598718,694564,283578,101618,404188,515157,413731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]