SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 74171 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 74171 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984293,120436,540515,910227,294368,336145,197377,51682,276989,421812,393402,2281,797708,110402,179352,254814,584254,801925,834742,487584,510900,624638,631975,451829,952949,786459,553316,515328,700384,523833,113552,449291,1003412,42312,789578,547533,443604,996,632929,644206,985555,1016091,140171,411468,930074,946973,331436,175151,394966,151703,773384,368440,782915,320759,667844,685941,323322,1044687,394672,1017497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 74171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 74171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]