SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413641 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413641 [ RunTime:0.002414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42037,586243,484872,737422,72173,851575,24598,299446,550389,580384,174961,829016,932317,806643,668391,404253,167586,863863,575156,641627,113938,375982,214872,930283,516707,485062,15315,409847,514480,45749,479113,154070,769408,46442,967917,241458,321811,703145,65876,85507,581244,366011,1017325,470825,503194,535888,809245,146205,688869,779388,883567,539759,191012,1039519,181763,425064,143101,987741,457005,107817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000751s ]