SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644091 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644091 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047814,973744,1023327,65485,267622,367275,614306,548825,300544,352034,1023426,995783,343886,244580,682221,89540,872577,277923,283846,637784,636867,537977,598362,467479,681251,684920,291976,1002587,792815,671779,107092,1008151,841898,679145,661908,455278,599140,52043,944124,534944,165074,221482,979748,373947,551119,361596,809066,328907,728525,568104,288657,873769,131413,84302,76485,762637,670273,19368,3957,373690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000800s ]