SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 845401 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 845401 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137656,629543,150166,698584,521937,68938,436450,285558,301216,151513,794312,212188,804721,404079,19116,805457,88454,870591,349488,389905,605362,185028,1043227,392135,1001904,562115,327096,1005699,830228,882939,275873,55042,485424,665135,957431,150820,562970,958756,873748,882917,899739,329704,652781,607277,832520,1043125,884474,420164,249947,218719,278225,833218,812680,693046,240064,410581,388645,848349,675237,398208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 845401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 845401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]