SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423143 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423143 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880424,911492,186083,704070,586017,365569,384887,211529,1048436,961439,45457,161693,673090,22588,692103,656113,870624,397515,241018,1022522,310038,259085,316639,906590,382839,540246,21426,726104,755722,404856,543180,875210,256451,570559,204085,204611,970524,174180,203951,553573,641093,829764,965047,701215,943155,764100,652394,826856,608730,663112,742328,723708,950904,659590,963384,943156,140700,544916,896509,491530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]