SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261046 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261046 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028600,513309,718581,366059,688371,664772,56786,696834,135741,558227,317908,44809,622874,96599,860029,9476,226877,432545,255154,1024771,428462,498156,499087,507301,478661,770388,896436,103542,814708,823620,286110,355900,1044614,961261,792007,55859,640575,689117,712525,682218,338873,358219,895980,583134,298350,792690,236757,265793,176859,907679,847846,107223,935811,199816,437628,768994,161396,12705,283083,523540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001495s ]