SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030447 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030447 [ RunTime:0.003055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402576,315579,287160,494381,971749,502001,391348,795823,448382,370223,425365,65918,986291,416836,500040,1021748,1012431,118915,652827,220498,96975,381870,579589,438506,567503,842279,539692,26479,589196,482614,498745,465038,725896,66337,447548,1023932,122403,248779,495649,669655,130470,575452,750407,329392,169838,21334,326867,852241,548373,499383,500258,188491,1029359,392462,115837,291590,641525,580052,973089,99959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]