SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299245 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299245 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591090,140964,886789,926579,699737,489025,460279,894000,467986,473305,1034321,453953,621666,333844,641933,353107,827177,852850,328828,173405,669558,92204,738929,100768,871814,131514,943304,1027976,336365,798041,572651,603214,474703,398172,4364,257103,792161,405817,83831,917421,980073,215716,334104,291742,103285,60312,361331,450568,454399,978161,928823,320505,120796,159392,794600,326135,18236,365368,261457,1015212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]