SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434477 LIMIT 1 [ RunTime:0.000653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434477 [ RunTime:0.003586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18103,879916,671040,439067,543571,1044868,778637,556779,78503,570815,94235,206040,675138,374949,922524,574538,146449,994080,478232,201297,361890,624291,452939,240504,519162,70241,291533,132203,332012,849378,22306,237651,671964,404835,872972,920840,8522,454369,1031516,414430,643606,813664,101832,955521,156737,1038603,768796,281257,257671,998789,840830,336397,270199,1008550,233075,813093,236431,925871,797027,794209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000988s ]