SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195039 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195039 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562210,337781,591229,156003,955495,433088,795353,524871,826258,93930,275404,592087,502099,752350,598839,167255,190666,738400,741465,585039,780675,221793,505062,338758,457577,866941,947701,39708,480831,19582,458382,867505,343814,120671,951504,531463,130552,592171,717706,266763,624990,6064,258066,449949,458683,267505,425441,136039,439543,373217,184166,278848,646183,420992,190404,890176,839760,372989,31398,490139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003421s ]