SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481629 LIMIT 1 [ RunTime:0.001174s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481629 [ RunTime:0.000980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864918,441437,564923,391579,23990,907245,316200,195626,1032798,447781,1043671,336603,611624,860042,473979,138442,790702,641281,904011,422294,228977,807332,779556,675006,247643,913310,625171,403308,730727,1016554,792938,462826,412185,327161,966777,787579,981860,63437,916831,25557,1044068,38815,855334,524414,28482,552147,143997,165779,631170,1003136,487553,431418,596427,186573,111772,742144,642115,192856,479006,664076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]