SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348052 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348052 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005104,512251,123720,956828,102617,258924,132212,219872,826699,366905,380789,826695,179795,304962,709516,434657,516433,823048,877353,277493,255402,655276,449301,935165,730723,843925,491451,180780,303163,702505,333,477485,373150,769132,193799,419410,148035,913219,471871,943030,419161,868835,529934,484861,618691,281522,207299,596237,160006,994534,263413,691471,730030,794140,792991,807852,868778,935639,344328,356893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]