SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493309 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493309 [ RunTime:0.003171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129712,342490,751854,260206,499118,1002943,1043061,306514,1328,688808,276088,600442,141624,1010793,804056,817467,562095,330921,462470,474497,189377,614983,560013,823858,869990,811435,809957,948651,457478,670011,93600,299895,293506,291408,631644,895508,942561,156446,979621,932386,576117,497980,277753,37795,843748,238012,540710,465128,882282,178096,740832,221668,282689,795163,130167,830876,113092,75440,584827,403845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]