SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281616 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281616 [ RunTime:0.003065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436804,725851,362892,485058,72210,616291,253267,651875,1005637,971140,413307,261509,56669,188035,715294,972425,451331,42891,499066,800755,495664,695106,41843,10549,553072,447525,558571,427203,885041,774421,704198,152379,294504,970372,913211,57686,82929,876737,642166,960656,538774,787893,424166,705570,941398,629670,1036576,155864,393620,137920,491568,1006573,49178,760220,638429,600644,106655,944126,553913,1005654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]