SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520301 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520301 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675880,366617,619431,171621,864484,913506,478918,237369,809553,728657,1013754,806175,998662,940113,742120,695928,996375,322316,668098,379801,520347,544382,210813,644189,119826,933523,792888,643172,138091,730411,149678,612484,1048285,512646,471832,658658,686414,785025,708602,577216,347305,896314,309447,259889,81858,263432,997556,465022,771834,946554,348621,423491,99102,299654,364485,631245,355028,255409,608824,491071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]