SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011004 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011004 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300536,609120,649017,97265,868014,3709,761330,1013144,195377,35240,56096,317443,636535,609879,310959,639261,360371,97215,331726,757695,1041450,13537,430650,332344,831542,314495,346069,233428,524026,765724,171388,957223,895885,827689,45280,782202,815774,815496,235036,875010,810535,489062,51808,15839,159287,111386,527524,398145,37152,199714,620596,165743,508746,159639,824555,371009,8639,343936,747589,419070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]