SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410614 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410614 [ RunTime:0.003251s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824488,628281,902893,73839,705876,408196,834022,275058,31466,440456,291748,603062,803647,242098,213447,585331,627977,1028540,700941,946974,379668,303167,438745,314034,398298,418895,194953,13654,549812,720668,691365,91081,675330,932250,418708,128118,1038583,689122,670848,687528,683358,865322,172675,986194,231344,841487,26808,584421,992676,85216,502741,622036,535763,473898,399841,938237,87541,333877,872052,858789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002256s ]