SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529663 LIMIT 1 [ RunTime:0.000939s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529663 [ RunTime:0.002915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499691,842785,790197,1016685,599297,128530,450590,58372,863290,1036117,351636,631747,683006,732656,186620,197293,797600,958962,155979,103953,916018,47126,41950,266849,211714,626343,342871,775281,491192,207710,134484,850681,978664,293978,410974,262167,383530,361137,931708,418983,730375,972291,616035,858709,664826,913424,159682,152115,402908,198691,511980,381962,798911,804440,15616,306965,521074,628964,927775,34096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]