SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58445 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58445 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020774,951651,932627,628958,174561,863580,126733,748048,619018,294450,195656,284850,116158,938800,757668,462530,208303,285131,771871,180399,931165,54148,448001,493283,640456,201781,1044785,647034,402452,811306,590373,457911,428000,716089,768996,374998,191581,160903,729318,976710,620606,419276,246227,606712,16063,891424,22113,978056,942771,94709,421678,763363,450645,111479,242629,452668,808989,496469,896779,16673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]