SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527913 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527913 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295361,387330,173601,639938,906660,413101,320306,449169,303339,577696,981440,239411,123050,531609,745768,615712,655306,42855,796758,947649,870346,691131,198698,993463,154761,325346,575699,193050,215461,351168,258989,655279,474259,210716,991564,444017,986232,982313,895548,766341,476850,438443,194583,48547,1035903,141123,277606,103836,675908,309924,243048,615314,175033,954095,103855,642197,824346,108978,669534,174274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]