SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442358 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442358 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037254,748593,27181,521184,394839,348662,975128,143838,913160,667950,766614,143850,301070,2534,205494,271388,192569,777762,286995,718911,754323,650369,792153,931557,173718,524715,949858,893040,1003923,575794,370899,37995,281890,769841,598191,947528,81441,983113,312145,884491,1035518,470827,335635,456344,660252,92735,74090,75885,733491,406147,6644,300475,829276,359641,679159,707974,516398,639608,527923,111070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]