SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030037 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030037 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471541,312794,499055,937748,712308,507671,714068,548680,568052,414861,633011,414388,477553,30686,638143,321788,456765,592965,811882,796102,61962,178448,90935,462400,488046,304349,781248,280025,183980,447306,768657,838563,5385,3327,65446,762723,597480,403526,424033,894974,724379,554474,156536,294991,372241,210436,693296,842219,261711,242564,158780,901184,168086,940597,178475,217385,560982,745351,861638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]