SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441246 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441246 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131499,37600,833542,39669,17123,127546,843968,99110,388242,140398,384726,591978,941164,581469,56094,872585,1020860,737559,709335,895578,287535,1027636,71873,835946,274815,370600,416818,1023987,470460,269723,606595,781030,256077,856326,295188,542137,655813,913880,652264,21458,253839,474101,460290,219044,756297,100569,436504,824519,985477,570133,706188,175107,341601,615264,136609,1016399,427211,130229,675163,500398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]