SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 60383 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 60383 [ RunTime:0.002964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991812,1022743,121528,59017,610614,373538,372541,142419,490512,419020,443522,1028672,703793,1031969,220017,68418,571134,597141,331281,542368,964756,711554,204513,310827,849621,975206,976621,1021713,694242,170198,694040,310070,411903,615188,57167,436300,271019,586759,654440,733914,577949,970976,1026907,164701,30595,732077,244605,359116,717452,663823,43260,305553,352737,750904,549752,755548,667455,6125,650357,821390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 60383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 60383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]