SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526179 LIMIT 1 [ RunTime:0.000763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526179 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315506,280760,473226,205828,667482,899979,1044781,380834,596694,378020,69237,383207,261424,858564,161212,760677,433102,824512,820255,963412,35656,337569,570429,1044893,325805,165832,15414,890953,385552,482187,424008,778338,775676,867996,842751,1001616,914478,192214,141669,245284,1026387,56032,909889,453357,884663,721759,642251,968739,66276,416741,794969,821437,107025,439941,441924,199732,780616,725404,928493,926876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]