SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510729 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510729 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298905,710729,157994,848313,21169,931289,471750,839780,630454,716744,1041429,456826,400032,441554,736203,608585,851898,88670,954316,783691,454200,538855,162642,749839,694583,366168,199587,654538,793100,820285,717203,923852,732355,440176,272255,145118,549281,1043506,523214,1005689,142219,133893,558934,65664,55187,403854,119488,714520,874799,1005917,204551,156078,913006,1033979,447134,124291,651798,126216,165281,846714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]