SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534992 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534992 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752011,730289,739042,79877,682835,815283,592208,988860,752093,470318,370903,438808,709734,846684,927691,438877,804751,982980,946413,354356,58828,282399,815220,714031,56049,242420,971015,340677,285321,834394,721263,465575,642860,1035781,616572,453645,777885,504835,687633,1015647,701542,548616,566803,481069,784578,284928,659247,176583,182563,1006075,504777,146488,16732,1024968,742975,314820,273584,246711,202850,377699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]