SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333531 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333531 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039969,757964,956781,303479,425231,506832,69182,388773,633064,788714,892986,710835,3624,921334,238352,510901,490564,113803,963309,785585,567860,426503,786187,451204,231861,698074,760733,246466,423606,123350,774249,147981,510288,800258,858926,151501,61407,73652,807378,945613,25967,580601,163842,350205,497473,1005347,804746,1044323,627416,40817,619156,875027,440327,366849,246493,125825,71251,1024791,393194,43225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]